﻿CREATE TABLE [org].[Programme] (
    [ProgrammeId]          INT             NOT NULL,
    [ProgrammeCode]        CHAR (5)        NOT NULL,
    [ProgrammeName]        VARCHAR (50)    NOT NULL,
    [ProgrammeDescription] NVARCHAR (1000) NULL,
    [ProgrammeStartDate]   DATE            NOT NULL,
    [ProgrammeEndDate]     DATE            NULL,
    [IsLatest]             BIT             NOT NULL,
    [IsActive]             BIT             NOT NULL,
    [IsInternal]           BIT             NOT NULL,
    PRIMARY KEY CLUSTERED ([ProgrammeId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

